package com.trmp.base.shoppingMng.dao;


import java.util.List;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import com.trmp.base.shoppingMng.entity.BaseShoppingFeeInfo;
import com.trmp.base.shoppingMng.entity.BaseShoppingStoreInfo;
import com.trmp.commons.dao.GenericRepository;

public interface ShoppingFeeInfoDao extends GenericRepository<BaseShoppingFeeInfo, Long>{

	public List<BaseShoppingFeeInfo> findByShoppingStore(BaseShoppingStoreInfo store);
	@Modifying
	@Query(value="delete from T_BASE_SHOPPINGROOM_FEE where SHOPPINGROOMID=?1",nativeQuery=true)
	public void deleteByShoppingStore(BaseShoppingStoreInfo store);

	public void deleteFeesByShoppingId(List<Long> list);
}
